from soufang import db

class Urls(db.Model):
	id = db.Column(db.Integer, primary_key = True)
	addr = db.Column(db.String(64), nullable = False)

class Fangs(db.Model):
	id = db.Column(db.Integer, primary_key = True)
	xiaoqu = db.Column(db.Text, nullable = False)
	agent_name = db.Column(db.Text, nullable = False)
	storageimg = db.Column(db.Text, nullable = False)
	phone = db.Column(db.Text, nullable = False)
	title = db.Column(db.Text, nullable = False)
	price = db.Column(db.Text, nullable = False)
	room = db.Column(db.Text, nullable = False)
	area = db.Column(db.Text, nullable = False)
	zhname = db.Column(db.Text, nullable = False)
	purpose = db.Column(db.Text, nullable = False)
	district = db.Column(db.Text, nullable = False)
	comarea = db.Column(db.Text, nullable = False)
	url = db.Column(db.Text, nullable = False)
	hidden = db.Column(db.Text)
	
